USE [RD_ARMart]
GO

/****** Object:  Index [PK_AR_Star_FactsExt]    Script Date: 04/17/2010 07:51:19 ******/
ALTER TABLE [dbo].[AR_Star_FactsExt] ADD  CONSTRAINT [PK_AR_Star_FactsExt] PRIMARY KEY CLUSTERED 
(
	[DocumentNumber] ASC,
	[DocumentType] ASC,
	[PayItem] ASC,
	[DocumentCompany] ASC,
	[InternalPaymentID] ASC,
	[FileLineIdentifier] ASC,
	[InvoiceType] ASC,
	[PayItemExtensionNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


USE [RD_ARMart]
GO

/****** Object:  Index [IX_FactsExt_CheckClearedDate]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_CheckClearedDate] ON [dbo].[AR_Star_FactsExt] 
(
	[CheckClearedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_ClearedValDateID]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_ClearedValDateID] ON [dbo].[AR_Star_FactsExt] 
(
	[ClearedValueDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_DateExchangeRate]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_DateExchangeRate] ON [dbo].[AR_Star_FactsExt] 
(
	[DateForExchangeRateJulianID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_DateInvJournal]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_DateInvJournal] ON [dbo].[AR_Star_FactsExt] 
(
	[DateInvoiceJournalDateJulianID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_DateLastFeeCJ]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_DateLastFeeCJ] ON [dbo].[AR_Star_FactsExt] 
(
	[DateLastFeeCalculatedJulianID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_DateLastSR]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_DateLastSR] ON [dbo].[AR_Star_FactsExt] 
(
	[DateOfLastSentReminderID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_FactExtID]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_FactExtID] ON [dbo].[AR_Star_FactsExt] 
(
	[FactsExtID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_HistoricalDate]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_HistoricalDate] ON [dbo].[AR_Star_FactsExt] 
(
	[HistoricalDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_InternalPaymentID]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_InternalPaymentID] ON [dbo].[AR_Star_FactsExt] 
(
	[InternalPaymentID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_NotificationPayDt]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_NotificationPayDt] ON [dbo].[AR_Star_FactsExt] 
(
	[NotificationPaymentDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_OrigDateNetDue]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_OrigDateNetDue] ON [dbo].[AR_Star_FactsExt] 
(
	[OriginalDateNetDueID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_ReminderStopUD]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_ReminderStopUD] ON [dbo].[AR_Star_FactsExt] 
(
	[ReminderStopUntilDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_StatementDateID]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_StatementDateID] ON [dbo].[AR_Star_FactsExt] 
(
	[StatementDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [IX_FactsExt_UserResDateID]    Script Date: 04/17/2010 07:51:13 ******/
CREATE NONCLUSTERED INDEX [IX_FactsExt_UserResDateID] ON [dbo].[AR_Star_FactsExt] 
(
	[UserReservedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO


